Dataset statistics
| Number of variables | 43 |
|---|---|
| Number of observations | 2535791 |
| Missing cells | 62676385 |
| Missing cells (%) | 57.5% |
| Duplicate rows | 238112 |
| Duplicate rows (%) | 9.4% |
| Total size in memory | 831.9 MiB |
| Average record size in memory | 344.0 B |
Variable types
| NUM | 18 |
|---|---|
| UNSUPPORTED | 13 |
| CAT | 12 |
| Dataset has 238112 (9.4%) duplicate rows | Duplicates |
Date mutation has a high cardinality: 361 distinct values | High cardinality |
Type de voie has a high cardinality: 137 distinct values | High cardinality |
Code voie has a high cardinality: 16233 distinct values | High cardinality |
Voie has a high cardinality: 357364 distinct values | High cardinality |
Commune has a high cardinality: 29380 distinct values | High cardinality |
Section has a high cardinality: 583 distinct values | High cardinality |
Nature culture speciale has a high cardinality: 118 distinct values | High cardinality |
5eme lot is highly correlated with 4eme lot | High correlation |
4eme lot is highly correlated with 5eme lot | High correlation |
Type local is highly correlated with Code type local | High correlation |
Code type local is highly correlated with Type local | High correlation |
Code service CH has 2535791 (100.0%) missing values | Missing |
Reference document has 2535791 (100.0%) missing values | Missing |
1 Articles CGI has 2535791 (100.0%) missing values | Missing |
2 Articles CGI has 2535791 (100.0%) missing values | Missing |
3 Articles CGI has 2535791 (100.0%) missing values | Missing |
4 Articles CGI has 2535791 (100.0%) missing values | Missing |
5 Articles CGI has 2535791 (100.0%) missing values | Missing |
Valeur fonciere has 29261 (1.2%) missing values | Missing |
No voie has 1025638 (40.4%) missing values | Missing |
B/T/Q has 2426362 (95.7%) missing values | Missing |
Type de voie has 1053720 (41.6%) missing values | Missing |
Code voie has 28189 (1.1%) missing values | Missing |
Voie has 28354 (1.1%) missing values | Missing |
Code postal has 28323 (1.1%) missing values | Missing |
Prefixe de section has 2408956 (95.0%) missing values | Missing |
No Volume has 2529165 (99.7%) missing values | Missing |
1er lot has 1753172 (69.1%) missing values | Missing |
Surface Carrez du 1er lot has 2314726 (91.3%) missing values | Missing |
2eme lot has 2372713 (93.6%) missing values | Missing |
Surface Carrez du 2eme lot has 2481517 (97.9%) missing values | Missing |
3eme lot has 2509709 (99.0%) missing values | Missing |
Surface Carrez du 3eme lot has 2530577 (99.8%) missing values | Missing |
4eme lot has 2526555 (99.6%) missing values | Missing |
Surface Carrez du 4eme lot has 2534376 (99.9%) missing values | Missing |
5eme lot has 2531364 (99.8%) missing values | Missing |
Surface Carrez du 5eme lot has 2535182 (> 99.9%) missing values | Missing |
Code type local has 1182459 (46.6%) missing values | Missing |
Type local has 1182459 (46.6%) missing values | Missing |
Identifiant local has 2535791 (100.0%) missing values | Missing |
Surface reelle bati has 1184176 (46.7%) missing values | Missing |
Nombre pieces principales has 1184176 (46.7%) missing values | Missing |
Nature culture has 792958 (31.3%) missing values | Missing |
Nature culture speciale has 2422938 (95.5%) missing values | Missing |
Surface terrain has 792958 (31.3%) missing values | Missing |
No disposition is highly skewed (γ1 = 70.78417421) | Skewed |
Valeur fonciere is highly skewed (γ1 = 50.14941634) | Skewed |
Surface Carrez du 1er lot is highly skewed (γ1 = 41.61602856) | Skewed |
Surface Carrez du 2eme lot is highly skewed (γ1 = 68.81132406) | Skewed |
Nombre de lots is highly skewed (γ1 = 28.12730824) | Skewed |
Surface reelle bati is highly skewed (γ1 = 188.7084892) | Skewed |
Surface terrain is highly skewed (γ1 = 44.79390898) | Skewed |
Code service CH is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reference document is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
1 Articles CGI is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
2 Articles CGI is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
3 Articles CGI is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
4 Articles CGI is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
5 Articles CGI is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Code departement is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
No Volume is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
1er lot is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
2eme lot is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
3eme lot is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Identifiant local is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Nombre de lots has 1753172 (69.1%) zeros | Zeros |
Surface reelle bati has 316200 (12.5%) zeros | Zeros |
Nombre pieces principales has 406960 (16.0%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-22 01:28:42.266443 |
|---|---|
| Analysis finished | 2020-10-22 01:47:41.254186 |
| Duration | 18 minutes and 58.99 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 620 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.199535372 |
|---|---|
| Minimum | 1 |
| Maximum | 694 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 694 |
| Range | 693 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.401536829 |
|---|---|
| Coefficient of variation (CV) | 6.170336451 |
| Kurtosis | 5363.725904 |
| Mean | 1.199535372 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 70.78417421 |
| Sum | 3041771 |
| Variance | 54.78274742 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 2390187 | 94.3% | |
| 2 | 120232 | 4.7% | |
| 3 | 16449 | 0.6% | |
| 4 | 2927 | 0.1% | |
| 5 | 1286 | 0.1% | |
| 6 | 928 | < 0.1% | |
| 7 | 664 | < 0.1% | |
| 10 | 340 | < 0.1% | |
| 8 | 202 | < 0.1% | |
| 9 | 179 | < 0.1% | |
| Other values (610) | 2397 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 2390187 | 94.3% | |
| 2 | 120232 | 4.7% | |
| 3 | 16449 | 0.6% | |
| 4 | 2927 | 0.1% | |
| 5 | 1286 | 0.1% |
| Value | Count | Frequency (%) | |
| 694 | 1 | < 0.1% | |
| 693 | 1 | < 0.1% | |
| 692 | 1 | < 0.1% | |
| 691 | 1 | < 0.1% | |
| 690 | 1 | < 0.1% |
| Distinct | 361 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.3 MiB |
| 29/03/2019 | 22208 |
|---|---|
| 28/06/2019 | 22165 |
| 29/05/2019 | 18948 |
| 28/02/2019 | 17537 |
| 30/04/2019 | 17332 |
| Other values (356) |
| Value | Count | Frequency (%) | |
| 29/03/2019 | 22208 | 0.9% | |
| 28/06/2019 | 22165 | 0.9% | |
| 29/05/2019 | 18948 | 0.7% | |
| 28/02/2019 | 17537 | 0.7% | |
| 30/04/2019 | 17332 | 0.7% | |
| 31/01/2019 | 17126 | 0.7% | |
| 20/12/2019 | 16089 | 0.6% | |
| 15/03/2019 | 15716 | 0.6% | |
| 26/04/2019 | 15652 | 0.6% | |
| 28/05/2019 | 15360 | 0.6% | |
| Other values (351) | 2357658 | 93.0% |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Nature mutation
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.3 MiB |
| Vente | |
|---|---|
| Vente en l'état futur d'achèvement | 185441 |
| Echange | 27127 |
| Vente terrain à bâtir | 7806 |
| Adjudication | 4819 |
| Value | Count | Frequency (%) | |
| Vente | 2308539 | 91.0% | |
| Vente en l'état futur d'achèvement | 185441 | 7.3% | |
| Echange | 27127 | 1.1% | |
| Vente terrain à bâtir | 7806 | 0.3% | |
| Adjudication | 4819 | 0.2% | |
| Expropriation | 2059 | 0.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 34 |
|---|---|
| Median length | 5 |
| Mean length | 7.21120116 |
| Min length | 5 |
| Distinct | 108435 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 29261 |
| Missing (%) | 1.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 971597.0403 |
|---|---|
| Minimum | 0.01 |
| Maximum | 2086000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 2700 |
| Q1 | 60000 |
| median | 149000 |
| Q3 | 269000 |
| 95-th percentile | 1350000 |
| Maximum | 2086000000 |
| Range | 2086000000 |
| Interquartile range (IQR) | 209000 |
Descriptive statistics
| Standard deviation | 7856913.856 |
|---|---|
| Coefficient of variation (CV) | 8.08659715 |
| Kurtosis | 7985.25884 |
| Mean | 971597.0403 |
| Median Absolute Deviation (MAD) | 99000 |
| Skewness | 50.14941634 |
| Sum | 2.435337129e+12 |
| Variance | 6.173109535e+13 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 100000 | 21742 | 0.9% | |
| 150000 | 21157 | 0.8% | |
| 120000 | 19573 | 0.8% | |
| 80000 | 18482 | 0.7% | |
| 1 | 18101 | 0.7% | |
| 130000 | 17634 | 0.7% | |
| 110000 | 17424 | 0.7% | |
| 200000 | 17233 | 0.7% | |
| 50000 | 17153 | 0.7% | |
| 140000 | 17150 | 0.7% | |
| Other values (108425) | 2320881 | 91.5% | |
| (Missing) | 29261 | 1.2% |
| Value | Count | Frequency (%) | |
| 0.01 | 2 | < 0.1% | |
| 0.1 | 12 | < 0.1% | |
| 0.15 | 123 | < 0.1% | |
| 0.16 | 3 | < 0.1% | |
| 0.18 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2086000000 | 2 | < 0.1% | |
| 1750000000 | 3 | < 0.1% | |
| 845000000 | 2 | < 0.1% | |
| 690186750 | 24 | < 0.1% | |
| 612990460 | 6 | < 0.1% |
| Distinct | 6577 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1025638 |
| Missing (%) | 40.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 727.0275005 |
|---|---|
| Minimum | 1 |
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 24 |
| Q3 | 87 |
| 95-th percentile | 5633 |
| Maximum | 9999 |
| Range | 9998 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 2076.793685 |
|---|---|
| Coefficient of variation (CV) | 2.856554509 |
| Kurtosis | 8.223053939 |
| Mean | 727.0275005 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 3.062480081 |
| Sum | 1097922761 |
| Variance | 4313072.01 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 67975 | 2.7% | |
| 2 | 60703 | 2.4% | |
| 4 | 48221 | 1.9% | |
| 3 | 48141 | 1.9% | |
| 5 | 43107 | 1.7% | |
| 6 | 42181 | 1.7% | |
| 7 | 37754 | 1.5% | |
| 8 | 37157 | 1.5% | |
| 9 | 34252 | 1.4% | |
| 10 | 34058 | 1.3% | |
| Other values (6567) | 1056604 | 41.7% | |
| (Missing) | 1025638 | 40.4% |
| Value | Count | Frequency (%) | |
| 1 | 67975 | 2.7% | |
| 2 | 60703 | 2.4% | |
| 3 | 48141 | 1.9% | |
| 4 | 48221 | 1.9% | |
| 5 | 43107 | 1.7% |
| Value | Count | Frequency (%) | |
| 9999 | 261 | < 0.1% | |
| 9998 | 67 | < 0.1% | |
| 9997 | 11 | < 0.1% | |
| 9996 | 15 | < 0.1% | |
| 9995 | 15 | < 0.1% |
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2426362 |
| Missing (%) | 95.7% |
| Memory size | 19.3 MiB |
| B | |
|---|---|
| A | |
| T | |
| F | |
| C | 3187 |
| Other values (35) | 6200 |
| Value | Count | Frequency (%) | |
| B | 66043 | 2.6% | |
| A | 16849 | 0.7% | |
| T | 8914 | 0.4% | |
| F | 8236 | 0.3% | |
| C | 3187 | 0.1% | |
| D | 1493 | 0.1% | |
| Q | 985 | < 0.1% | |
| E | 890 | < 0.1% | |
| P | 574 | < 0.1% | |
| G | 395 | < 0.1% | |
| Other values (30) | 1863 | 0.1% | |
| (Missing) | 2426362 | 95.7% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.913692414 |
| Min length | 1 |
| Distinct | 137 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1053720 |
| Missing (%) | 41.6% |
| Memory size | 19.3 MiB |
| RUE | |
|---|---|
| AV | |
| RTE | 72401 |
| CHE | 71983 |
| BD | 67221 |
| Other values (132) |
| Value | Count | Frequency (%) | |
| RUE | 862542 | 34.0% | |
| AV | 195932 | 7.7% | |
| RTE | 72401 | 2.9% | |
| CHE | 71983 | 2.8% | |
| BD | 67221 | 2.7% | |
| ALL | 48966 | 1.9% | |
| IMP | 35154 | 1.4% | |
| PL | 28781 | 1.1% | |
| RES | 19975 | 0.8% | |
| QUAI | 7859 | 0.3% | |
| Other values (127) | 71257 | 2.8% | |
| (Missing) | 1053720 | 41.6% |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.887699736 |
| Min length | 1 |
| Distinct | 16233 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 28189 |
| Missing (%) | 1.1% |
| Memory size | 19.3 MiB |
| 0020 | 11086 |
|---|---|
| B005 | 11070 |
| 0040 | 10652 |
| B007 | 10557 |
| 0060 | 10434 |
| Other values (16228) |
| Value | Count | Frequency (%) | |
| 0020 | 11086 | 0.4% | |
| B005 | 11070 | 0.4% | |
| 0040 | 10652 | 0.4% | |
| B007 | 10557 | 0.4% | |
| 0060 | 10434 | 0.4% | |
| B003 | 10426 | 0.4% | |
| B006 | 10299 | 0.4% | |
| B008 | 10292 | 0.4% | |
| B016 | 10287 | 0.4% | |
| B002 | 10204 | 0.4% | |
| Other values (16223) | 2402295 | 94.7% | |
| (Missing) | 28189 | 1.1% |
Unique
| Unique | 1603 ? |
|---|---|
| Unique (%) | 0.1% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.988883548 |
| Min length | 3 |
| Distinct | 357364 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 28354 |
| Missing (%) | 1.1% |
| Memory size | 19.3 MiB |
| LE VILLAGE | 23596 |
|---|---|
| LE BOURG | 21852 |
| JEAN JAURES | 11542 |
| DE LA REPUBLIQUE | 11186 |
| VICTOR HUGO | 7845 |
| Other values (357359) |
| Value | Count | Frequency (%) | |
| LE VILLAGE | 23596 | 0.9% | |
| LE BOURG | 21852 | 0.9% | |
| JEAN JAURES | 11542 | 0.5% | |
| DE LA REPUBLIQUE | 11186 | 0.4% | |
| VICTOR HUGO | 7845 | 0.3% | |
| GRANDE RUE | 6721 | 0.3% | |
| PASTEUR | 6683 | 0.3% | |
| DE PARIS | 6031 | 0.2% | |
| DE LA GARE | 5966 | 0.2% | |
| DE LA LIBERATION | 5750 | 0.2% | |
| Other values (357354) | 2400265 | 94.7% | |
| (Missing) | 28354 | 1.1% |
Unique
| Unique | 126168 ? |
|---|---|
| Unique (%) | 5.0% |
Length
| Max length | 26 |
|---|---|
| Median length | 12 |
| Mean length | 12.46227745 |
| Min length | 1 |
| Distinct | 5797 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 28323 |
| Missing (%) | 1.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51976.36947 |
|---|---|
| Minimum | 1000 |
| Maximum | 97490 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 7100 |
| Q1 | 31230 |
| median | 50200 |
| Q3 | 77144 |
| 95-th percentile | 93300 |
| Maximum | 97490 |
| Range | 96490 |
| Interquartile range (IQR) | 45914 |
Descriptive statistics
| Standard deviation | 27302.60504 |
|---|---|
| Coefficient of variation (CV) | 0.5252888056 |
| Kurtosis | -1.156558117 |
| Mean | 51976.36947 |
| Median Absolute Deviation (MAD) | 24100 |
| Skewness | -0.04981286052 |
| Sum | 1.303290832e+11 |
| Variance | 745432242.1 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 18000 | 7526 | 0.3% | |
| 51100 | 6844 | 0.3% | |
| 75015 | 6582 | 0.3% | |
| 75018 | 6411 | 0.3% | |
| 75016 | 6390 | 0.3% | |
| 76600 | 6056 | 0.2% | |
| 75017 | 5574 | 0.2% | |
| 44300 | 5416 | 0.2% | |
| 6000 | 5324 | 0.2% | |
| 44000 | 5114 | 0.2% | |
| Other values (5787) | 2446231 | 96.5% | |
| (Missing) | 28323 | 1.1% |
| Value | Count | Frequency (%) | |
| 1000 | 1040 | < 0.1% | |
| 1090 | 210 | < 0.1% | |
| 1100 | 888 | < 0.1% | |
| 1110 | 592 | < 0.1% | |
| 1120 | 299 | < 0.1% |
| Value | Count | Frequency (%) | |
| 97490 | 199 | < 0.1% | |
| 97480 | 293 | < 0.1% | |
| 97470 | 16 | < 0.1% | |
| 97460 | 40 | < 0.1% | |
| 97450 | 115 | < 0.1% |
| Distinct | 29380 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.3 MiB |
| TOULOUSE | 18045 |
|---|---|
| NANTES | 16576 |
| NICE | 15415 |
| BORDEAUX | 13463 |
| LILLE | 11705 |
| Other values (29375) |
| Value | Count | Frequency (%) | |
| TOULOUSE | 18045 | 0.7% | |
| NANTES | 16576 | 0.7% | |
| NICE | 15415 | 0.6% | |
| BORDEAUX | 13463 | 0.5% | |
| LILLE | 11705 | 0.5% | |
| NIMES | 8881 | 0.4% | |
| LE HAVRE | 8860 | 0.3% | |
| ANGERS | 8054 | 0.3% | |
| SAINT-ETIENNE | 7593 | 0.3% | |
| BOURGES | 7522 | 0.3% | |
| Other values (29370) | 2419677 | 95.4% |
Unique
| Unique | 789 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 30 |
|---|---|
| Median length | 9 |
| Mean length | 11.41841264 |
| Min length | 1 |
Code commune
Real number (ℝ≥0)
| Distinct | 908 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 208.9969296 |
|---|---|
| Minimum | 1 |
| Maximum | 909 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 76 |
| median | 174 |
| Q3 | 300 |
| 95-th percentile | 555 |
| Maximum | 909 |
| Range | 908 |
| Interquartile range (IQR) | 224 |
Descriptive statistics
| Standard deviation | 167.0736643 |
|---|---|
| Coefficient of variation (CV) | 0.7994072674 |
| Kurtosis | 0.5673820201 |
| Mean | 208.9969296 |
| Median Absolute Deviation (MAD) | 108 |
| Skewness | 1.013132693 |
| Sum | 529972533 |
| Variance | 27913.60932 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 63 | 25360 | 1.0% | |
| 109 | 23331 | 0.9% | |
| 88 | 20827 | 0.8% | |
| 555 | 19687 | 0.8% | |
| 7 | 18192 | 0.7% | |
| 4 | 17826 | 0.7% | |
| 33 | 15374 | 0.6% | |
| 218 | 15197 | 0.6% | |
| 194 | 14694 | 0.6% | |
| 1 | 14273 | 0.6% | |
| Other values (898) | 2351030 | 92.7% |
| Value | Count | Frequency (%) | |
| 1 | 14273 | 0.6% | |
| 2 | 9988 | 0.4% | |
| 3 | 11313 | 0.4% | |
| 4 | 17826 | 0.7% | |
| 5 | 11495 | 0.5% |
| Value | Count | Frequency (%) | |
| 909 | 10 | < 0.1% | |
| 908 | 55 | < 0.1% | |
| 907 | 46 | < 0.1% | |
| 906 | 51 | < 0.1% | |
| 905 | 35 | < 0.1% |
| Distinct | 710 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 2408956 |
| Missing (%) | 95.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 459.4845744 |
|---|---|
| Minimum | 1 |
| Maximum | 950 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 166 |
| median | 331 |
| Q3 | 829 |
| 95-th percentile | 880 |
| Maximum | 950 |
| Range | 949 |
| Interquartile range (IQR) | 663 |
Descriptive statistics
| Standard deviation | 326.0986731 |
|---|---|
| Coefficient of variation (CV) | 0.709705377 |
| Kurtosis | -1.699463289 |
| Mean | 459.4845744 |
| Median Absolute Deviation (MAD) | 265 |
| Skewness | 0.1634567861 |
| Sum | 58278726 |
| Variance | 106340.3446 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 166 | 2005 | 0.1% | |
| 830 | 1621 | 0.1% | |
| 831 | 1471 | 0.1% | |
| 844 | 1431 | 0.1% | |
| 839 | 1289 | 0.1% | |
| 828 | 1258 | < 0.1% | |
| 842 | 1241 | < 0.1% | |
| 177 | 1160 | < 0.1% | |
| 843 | 1088 | < 0.1% | |
| 841 | 1034 | < 0.1% | |
| Other values (700) | 113237 | 4.5% | |
| (Missing) | 2408956 | 95.0% |
| Value | Count | Frequency (%) | |
| 1 | 139 | < 0.1% | |
| 2 | 106 | < 0.1% | |
| 3 | 42 | < 0.1% | |
| 4 | 496 | < 0.1% | |
| 5 | 67 | < 0.1% |
| Value | Count | Frequency (%) | |
| 950 | 158 | < 0.1% | |
| 911 | 145 | < 0.1% | |
| 910 | 247 | < 0.1% | |
| 909 | 38 | < 0.1% | |
| 908 | 165 | < 0.1% |
| Distinct | 583 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 74 |
| Missing (%) | < 0.1% |
| Memory size | 19.3 MiB |
| A | 182703 |
|---|---|
| B | 174753 |
| C | 121195 |
| AB | 106184 |
| AC | 85653 |
| Other values (578) |
| Value | Count | Frequency (%) | |
| A | 182703 | 7.2% | |
| B | 174753 | 6.9% | |
| C | 121195 | 4.8% | |
| AB | 106184 | 4.2% | |
| AC | 85653 | 3.4% | |
| D | 83017 | 3.3% | |
| AD | 74002 | 2.9% | |
| AE | 66990 | 2.6% | |
| AH | 61627 | 2.4% | |
| AI | 58718 | 2.3% | |
| Other values (573) | 1520875 | 60.0% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.691832253 |
| Min length | 1 |
No plan
Real number (ℝ≥0)
| Distinct | 6356 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 403.7908471 |
|---|---|
| Minimum | 1 |
| Maximum | 9762 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 87 |
| median | 223 |
| Q3 | 504 |
| 95-th percentile | 1374 |
| Maximum | 9762 |
| Range | 9761 |
| Interquartile range (IQR) | 417 |
Descriptive statistics
| Standard deviation | 554.6664385 |
|---|---|
| Coefficient of variation (CV) | 1.373647874 |
| Kurtosis | 27.45317251 |
| Mean | 403.7908471 |
| Median Absolute Deviation (MAD) | 166 |
| Skewness | 4.053965317 |
| Sum | 1023929196 |
| Variance | 307654.858 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 10597 | 0.4% | |
| 5 | 9458 | 0.4% | |
| 3 | 9403 | 0.4% | |
| 7 | 9309 | 0.4% | |
| 19 | 9091 | 0.4% | |
| 22 | 8957 | 0.4% | |
| 2 | 8889 | 0.4% | |
| 6 | 8850 | 0.3% | |
| 4 | 8811 | 0.3% | |
| 15 | 8619 | 0.3% | |
| Other values (6346) | 2443807 | 96.4% |
| Value | Count | Frequency (%) | |
| 1 | 10597 | 0.4% | |
| 2 | 8889 | 0.4% | |
| 3 | 9403 | 0.4% | |
| 4 | 8811 | 0.3% | |
| 5 | 9458 | 0.4% |
| Value | Count | Frequency (%) | |
| 9762 | 1 | < 0.1% | |
| 9759 | 1 | < 0.1% | |
| 9757 | 1 | < 0.1% | |
| 9731 | 1 | < 0.1% | |
| 9730 | 1 | < 0.1% |
| Distinct | 17117 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 2314726 |
| Missing (%) | 91.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.97691502 |
|---|---|
| Minimum | 0.14 |
| Maximum | 9646.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0.14 |
|---|---|
| 5-th percentile | 16.04 |
| Q1 | 33.7 |
| median | 52.9 |
| Q3 | 72.67 |
| 95-th percentile | 116.15 |
| Maximum | 9646.2 |
| Range | 9646.06 |
| Interquartile range (IQR) | 38.97 |
Descriptive statistics
| Standard deviation | 91.91765768 |
|---|---|
| Coefficient of variation (CV) | 1.507417318 |
| Kurtosis | 2886.916952 |
| Mean | 60.97691502 |
| Median Absolute Deviation (MAD) | 19.45 |
| Skewness | 41.61602856 |
| Sum | 13479861.72 |
| Variance | 8448.855793 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 12.5 | 897 | < 0.1% | |
| 12 | 449 | < 0.1% | |
| 15 | 270 | < 0.1% | |
| 10 | 250 | < 0.1% | |
| 13 | 245 | < 0.1% | |
| 30 | 223 | < 0.1% | |
| 40 | 203 | < 0.1% | |
| 50 | 192 | < 0.1% | |
| 25 | 190 | < 0.1% | |
| 20 | 188 | < 0.1% | |
| Other values (17107) | 217958 | 8.6% | |
| (Missing) | 2314726 | 91.3% |
| Value | Count | Frequency (%) | |
| 0.14 | 1 | < 0.1% | |
| 0.26 | 1 | < 0.1% | |
| 0.36 | 1 | < 0.1% | |
| 0.5 | 1 | < 0.1% | |
| 0.61 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9646.2 | 1 | < 0.1% | |
| 9101 | 1 | < 0.1% | |
| 8946 | 1 | < 0.1% | |
| 8719.9 | 1 | < 0.1% | |
| 7634 | 1 | < 0.1% |
| Distinct | 11544 |
|---|---|
| Distinct (%) | 21.3% |
| Missing | 2481517 |
| Missing (%) | 97.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.39926945 |
|---|---|
| Minimum | 0.13 |
| Maximum | 8630 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0.13 |
|---|---|
| 5-th percentile | 23.1865 |
| Q1 | 42.75 |
| median | 60.6 |
| Q3 | 76.04 |
| 95-th percentile | 110.2835 |
| Maximum | 8630 |
| Range | 8629.87 |
| Interquartile range (IQR) | 33.29 |
Descriptive statistics
| Standard deviation | 58.86704493 |
|---|---|
| Coefficient of variation (CV) | 0.9285129852 |
| Kurtosis | 8774.357642 |
| Mean | 63.39926945 |
| Median Absolute Deviation (MAD) | 16.76 |
| Skewness | 68.81132406 |
| Sum | 3440931.95 |
| Variance | 3465.328979 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 69.16 | 103 | < 0.1% | |
| 20.43 | 70 | < 0.1% | |
| 55 | 46 | < 0.1% | |
| 50 | 42 | < 0.1% | |
| 67 | 41 | < 0.1% | |
| 65 | 39 | < 0.1% | |
| 54 | 39 | < 0.1% | |
| 28 | 38 | < 0.1% | |
| 60 | 37 | < 0.1% | |
| 63 | 35 | < 0.1% | |
| Other values (11534) | 53784 | 2.1% | |
| (Missing) | 2481517 | 97.9% |
| Value | Count | Frequency (%) | |
| 0.13 | 1 | < 0.1% | |
| 0.3 | 1 | < 0.1% | |
| 0.54 | 1 | < 0.1% | |
| 0.58 | 1 | < 0.1% | |
| 0.63 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8630 | 1 | < 0.1% | |
| 3583.64 | 1 | < 0.1% | |
| 3006.59 | 1 | < 0.1% | |
| 2520 | 1 | < 0.1% | |
| 2111.68 | 1 | < 0.1% |
| Distinct | 3961 |
|---|---|
| Distinct (%) | 76.0% |
| Missing | 2530577 |
| Missing (%) | 99.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73.17790756 |
|---|---|
| Minimum | 0.85 |
| Maximum | 3583.64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 38.105 |
| median | 60.6 |
| Q3 | 85.1875 |
| 95-th percentile | 171.198 |
| Maximum | 3583.64 |
| Range | 3582.79 |
| Interquartile range (IQR) | 47.0825 |
Descriptive statistics
| Standard deviation | 90.46654054 |
|---|---|
| Coefficient of variation (CV) | 1.236254815 |
| Kurtosis | 537.2559044 |
| Mean | 73.17790756 |
| Median Absolute Deviation (MAD) | 23.28 |
| Skewness | 17.57419094 |
| Sum | 381549.61 |
| Variance | 8184.194957 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 20.61 | 69 | < 0.1% | |
| 195.18 | 21 | < 0.1% | |
| 12.5 | 13 | < 0.1% | |
| 15 | 12 | < 0.1% | |
| 180.35 | 10 | < 0.1% | |
| 20 | 9 | < 0.1% | |
| 78 | 8 | < 0.1% | |
| 29.9 | 7 | < 0.1% | |
| 10 | 7 | < 0.1% | |
| 1 | 7 | < 0.1% | |
| Other values (3951) | 5051 | 0.2% | |
| (Missing) | 2530577 | 99.8% |
| Value | Count | Frequency (%) | |
| 0.85 | 1 | < 0.1% | |
| 1 | 7 | < 0.1% | |
| 1.22 | 1 | < 0.1% | |
| 1.25 | 1 | < 0.1% | |
| 1.33 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3583.64 | 1 | < 0.1% | |
| 2128.86 | 1 | < 0.1% | |
| 1699.39 | 1 | < 0.1% | |
| 1480.16 | 1 | < 0.1% | |
| 1300 | 1 | < 0.1% |
| Distinct | 688 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 2526555 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.2001949 |
|---|---|
| Minimum | 2 |
| Maximum | 17014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 7 |
| median | 24 |
| Q3 | 68 |
| 95-th percentile | 349 |
| Maximum | 17014 |
| Range | 17012 |
| Interquartile range (IQR) | 61 |
Descriptive statistics
| Standard deviation | 523.0737147 |
|---|---|
| Coefficient of variation (CV) | 4.620784577 |
| Kurtosis | 300.8019752 |
| Mean | 113.2001949 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | 14.89310183 |
| Sum | 1045517 |
| Variance | 273606.111 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 9 | 575 | < 0.1% | |
| 8 | 520 | < 0.1% | |
| 7 | 505 | < 0.1% | |
| 6 | 482 | < 0.1% | |
| 4 | 463 | < 0.1% | |
| 5 | 463 | < 0.1% | |
| 3 | 230 | < 0.1% | |
| 2 | 185 | < 0.1% | |
| 13 | 147 | < 0.1% | |
| 17 | 109 | < 0.1% | |
| Other values (678) | 5557 | 0.2% | |
| (Missing) | 2526555 | 99.6% |
| Value | Count | Frequency (%) | |
| 2 | 185 | < 0.1% | |
| 3 | 230 | < 0.1% | |
| 4 | 463 | < 0.1% | |
| 5 | 463 | < 0.1% | |
| 6 | 482 | < 0.1% |
| Value | Count | Frequency (%) | |
| 17014 | 1 | < 0.1% | |
| 11279 | 1 | < 0.1% | |
| 11045 | 1 | < 0.1% | |
| 11043 | 1 | < 0.1% | |
| 11041 | 1 | < 0.1% |
| Distinct | 1174 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 2534376 |
| Missing (%) | 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 86.96414841 |
|---|---|
| Minimum | 1 |
| Maximum | 3208.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10.528 |
| Q1 | 30.51 |
| median | 61.9 |
| Q3 | 100.275 |
| 95-th percentile | 220.733 |
| Maximum | 3208.9 |
| Range | 3207.9 |
| Interquartile range (IQR) | 69.765 |
Descriptive statistics
| Standard deviation | 146.2351366 |
|---|---|
| Coefficient of variation (CV) | 1.681556587 |
| Kurtosis | 192.7926595 |
| Mean | 86.96414841 |
| Median Absolute Deviation (MAD) | 34.76 |
| Skewness | 11.58141302 |
| Sum | 123054.27 |
| Variance | 21384.71518 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 20.99 | 68 | < 0.1% | |
| 115.75 | 21 | < 0.1% | |
| 53.93 | 8 | < 0.1% | |
| 12.5 | 7 | < 0.1% | |
| 20 | 6 | < 0.1% | |
| 11.52 | 4 | < 0.1% | |
| 49 | 4 | < 0.1% | |
| 88.6 | 4 | < 0.1% | |
| 15.9 | 4 | < 0.1% | |
| 72 | 4 | < 0.1% | |
| Other values (1164) | 1285 | 0.1% | |
| (Missing) | 2534376 | 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 3 | < 0.1% | |
| 1.55 | 1 | < 0.1% | |
| 1.8 | 1 | < 0.1% | |
| 2.33 | 1 | < 0.1% | |
| 3.09 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3208.9 | 1 | < 0.1% | |
| 2023 | 1 | < 0.1% | |
| 1612 | 1 | < 0.1% | |
| 1588.25 | 1 | < 0.1% | |
| 1362.6 | 1 | < 0.1% |
| Distinct | 480 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 2531364 |
| Missing (%) | 99.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 113.9613734 |
|---|---|
| Minimum | 2 |
| Maximum | 11046 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 8 |
| median | 27 |
| Q3 | 73 |
| 95-th percentile | 359 |
| Maximum | 11046 |
| Range | 11044 |
| Interquartile range (IQR) | 65 |
Descriptive statistics
| Standard deviation | 452.971562 |
|---|---|
| Coefficient of variation (CV) | 3.974781529 |
| Kurtosis | 170.5934583 |
| Mean | 113.9613734 |
| Median Absolute Deviation (MAD) | 21 |
| Skewness | 11.41445096 |
| Sum | 504507 |
| Variance | 205183.236 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 9 | 271 | < 0.1% | |
| 8 | 261 | < 0.1% | |
| 5 | 238 | < 0.1% | |
| 6 | 228 | < 0.1% | |
| 7 | 221 | < 0.1% | |
| 4 | 132 | < 0.1% | |
| 3 | 114 | < 0.1% | |
| 14 | 88 | < 0.1% | |
| 63 | 76 | < 0.1% | |
| 93 | 76 | < 0.1% | |
| Other values (470) | 2722 | 0.1% | |
| (Missing) | 2531364 | 99.8% |
| Value | Count | Frequency (%) | |
| 2 | 55 | < 0.1% | |
| 3 | 114 | < 0.1% | |
| 4 | 132 | < 0.1% | |
| 5 | 238 | < 0.1% | |
| 6 | 228 | < 0.1% |
| Value | Count | Frequency (%) | |
| 11046 | 1 | < 0.1% | |
| 7036 | 2 | < 0.1% | |
| 7005 | 1 | < 0.1% | |
| 6175 | 1 | < 0.1% | |
| 6074 | 1 | < 0.1% |
| Distinct | 473 |
|---|---|
| Distinct (%) | 77.7% |
| Missing | 2535182 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.38018062 |
|---|---|
| Minimum | 0.89 |
| Maximum | 1029.55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0.89 |
|---|---|
| 5-th percentile | 11.02 |
| Q1 | 23.79 |
| median | 65 |
| Q3 | 116.1 |
| 95-th percentile | 289.784 |
| Maximum | 1029.55 |
| Range | 1028.66 |
| Interquartile range (IQR) | 92.31 |
Descriptive statistics
| Standard deviation | 113.2562445 |
|---|---|
| Coefficient of variation (CV) | 1.200000294 |
| Kurtosis | 15.35982861 |
| Mean | 94.38018062 |
| Median Absolute Deviation (MAD) | 41.21 |
| Skewness | 3.299525784 |
| Sum | 57477.53 |
| Variance | 12826.97691 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 23.79 | 68 | < 0.1% | |
| 116.1 | 21 | < 0.1% | |
| 34.84 | 7 | < 0.1% | |
| 12.5 | 5 | < 0.1% | |
| 11.02 | 4 | < 0.1% | |
| 41.67 | 4 | < 0.1% | |
| 21.1 | 4 | < 0.1% | |
| 139.96 | 3 | < 0.1% | |
| 19 | 3 | < 0.1% | |
| 55.1 | 3 | < 0.1% | |
| Other values (463) | 487 | < 0.1% | |
| (Missing) | 2535182 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0.89 | 1 | < 0.1% | |
| 0.97 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 2.08 | 1 | < 0.1% | |
| 2.23 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1029.55 | 1 | < 0.1% | |
| 818.8 | 1 | < 0.1% | |
| 671.9 | 1 | < 0.1% | |
| 662.35 | 1 | < 0.1% | |
| 635.69 | 1 | < 0.1% |
| Distinct | 75 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3943329714 |
|---|---|
| Minimum | 0 |
| Maximum | 175 |
| Zeros | 1753172 |
| Zeros (%) | 69.1% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 175 |
| Range | 175 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.8086630828 |
|---|---|
| Coefficient of variation (CV) | 2.050711306 |
| Kurtosis | 3551.225082 |
| Mean | 0.3943329714 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 28.12730824 |
| Sum | 999946 |
| Variance | 0.6539359815 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 1753172 | 69.1% | |
| 1 | 619541 | 24.4% | |
| 2 | 136996 | 5.4% | |
| 3 | 16846 | 0.7% | |
| 4 | 4809 | 0.2% | |
| 5 | 1831 | 0.1% | |
| 6 | 887 | < 0.1% | |
| 7 | 484 | < 0.1% | |
| 8 | 296 | < 0.1% | |
| 9 | 197 | < 0.1% | |
| Other values (65) | 732 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 1753172 | 69.1% | |
| 1 | 619541 | 24.4% | |
| 2 | 136996 | 5.4% | |
| 3 | 16846 | 0.7% | |
| 4 | 4809 | 0.2% |
| Value | Count | Frequency (%) | |
| 175 | 1 | < 0.1% | |
| 159 | 1 | < 0.1% | |
| 142 | 1 | < 0.1% | |
| 141 | 1 | < 0.1% | |
| 114 | 1 | < 0.1% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1182459 |
| Missing (%) | 46.6% |
| Memory size | 19.3 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 |
| Value | Count | Frequency (%) | |
| 1 | 515398 | 20.3% | |
| 2 | 430975 | 17.0% | |
| 3 | 312480 | 12.3% | |
| 4 | 94479 | 3.7% | |
| (Missing) | 1182459 | 46.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1182459 |
| Missing (%) | 46.6% |
| Memory size | 19.3 MiB |
| Maison | |
|---|---|
| Appartement | |
| Dépendance | |
| Local industriel. commercial ou assimilé |
| Value | Count | Frequency (%) | |
| Maison | 515398 | 20.3% | |
| Appartement | 430975 | 17.0% | |
| Dépendance | 312480 | 12.3% | |
| Local industriel. commercial ou assimilé | 94479 | 3.7% | |
| (Missing) | 1182459 | 46.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 40 |
|---|---|
| Median length | 6 |
| Mean length | 7.21055087 |
| Min length | 3 |
| Distinct | 3879 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1184176 |
| Missing (%) | 46.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.75654014 |
|---|---|
| Minimum | 0 |
| Maximum | 312962 |
| Zeros | 316200 |
| Zeros (%) | 12.5% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 15 |
| median | 60 |
| Q3 | 94 |
| 95-th percentile | 170 |
| Maximum | 312962 |
| Range | 312962 |
| Interquartile range (IQR) | 79 |
Descriptive statistics
| Standard deviation | 872.8312276 |
|---|---|
| Coefficient of variation (CV) | 9.946053323 |
| Kurtosis | 49915.91499 |
| Mean | 87.75654014 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 188.7084892 |
| Sum | 118613056 |
| Variance | 761834.352 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 316200 | 12.5% | |
| 80 | 20159 | 0.8% | |
| 60 | 18734 | 0.7% | |
| 90 | 18209 | 0.7% | |
| 70 | 18207 | 0.7% | |
| 50 | 15590 | 0.6% | |
| 100 | 15582 | 0.6% | |
| 65 | 14476 | 0.6% | |
| 40 | 13615 | 0.5% | |
| 75 | 12640 | 0.5% | |
| Other values (3869) | 888203 | 35.0% | |
| (Missing) | 1184176 | 46.7% |
| Value | Count | Frequency (%) | |
| 0 | 316200 | 12.5% | |
| 1 | 271 | < 0.1% | |
| 2 | 224 | < 0.1% | |
| 3 | 277 | < 0.1% | |
| 4 | 155 | < 0.1% |
| Value | Count | Frequency (%) | |
| 312962 | 2 | < 0.1% | |
| 240000 | 2 | < 0.1% | |
| 215000 | 2 | < 0.1% | |
| 212120 | 2 | < 0.1% | |
| 152856 | 6 | < 0.1% |
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1184176 |
| Missing (%) | 46.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.430351099 |
|---|---|
| Minimum | 0 |
| Maximum | 67 |
| Zeros | 406960 |
| Zeros (%) | 16.0% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 67 |
| Range | 67 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.083948134 |
|---|---|
| Coefficient of variation (CV) | 0.8574679334 |
| Kurtosis | 2.659994281 |
| Mean | 2.430351099 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.574144641 |
| Sum | 3284899 |
| Variance | 4.342839825 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 406960 | 16.0% | |
| 4 | 229862 | 9.1% | |
| 3 | 225033 | 8.9% | |
| 2 | 164043 | 6.5% | |
| 5 | 137582 | 5.4% | |
| 1 | 102128 | 4.0% | |
| 6 | 53844 | 2.1% | |
| 7 | 19718 | 0.8% | |
| 8 | 7268 | 0.3% | |
| 9 | 2716 | 0.1% | |
| Other values (30) | 2461 | 0.1% | |
| (Missing) | 1184176 | 46.7% |
| Value | Count | Frequency (%) | |
| 0 | 406960 | 16.0% | |
| 1 | 102128 | 4.0% | |
| 2 | 164043 | 6.5% | |
| 3 | 225033 | 8.9% | |
| 4 | 229862 | 9.1% |
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 56 | 1 | < 0.1% | |
| 54 | 1 | < 0.1% | |
| 53 | 2 | < 0.1% | |
| 50 | 2 | < 0.1% |
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 792958 |
| Missing (%) | 31.3% |
| Memory size | 19.3 MiB |
| S | |
|---|---|
| T | |
| P | |
| J | |
| AB | |
| Other values (22) |
| Value | Count | Frequency (%) | |
| S | 839215 | 33.1% | |
| T | 258358 | 10.2% | |
| P | 130359 | 5.1% | |
| J | 93845 | 3.7% | |
| AB | 89648 | 3.5% | |
| BT | 74719 | 2.9% | |
| L | 63983 | 2.5% | |
| AG | 62807 | 2.5% | |
| VI | 29507 | 1.2% | |
| BR | 24929 | 1.0% | |
| Other values (17) | 75463 | 3.0% | |
| (Missing) | 792958 | 31.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.7599676 |
| Min length | 1 |
| Distinct | 118 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2422938 |
| Missing (%) | 95.5% |
| Memory size | 19.3 MiB |
| POTAG | |
|---|---|
| PIN | |
| PARC | |
| PATUR | |
| FRICH | |
| Other values (113) |
| Value | Count | Frequency (%) | |
| POTAG | 27853 | 1.1% | |
| PIN | 9982 | 0.4% | |
| PARC | 9910 | 0.4% | |
| PATUR | 9839 | 0.4% | |
| FRICH | 6332 | 0.2% | |
| VAOC | 5177 | 0.2% | |
| CHAT | 3672 | 0.1% | |
| IMM | 3581 | 0.1% | |
| CHENE | 2651 | 0.1% | |
| MARAI | 2609 | 0.1% | |
| Other values (108) | 31247 | 1.2% | |
| (Missing) | 2422938 | 95.5% |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.065863867 |
| Min length | 3 |
| Distinct | 41332 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 792958 |
| Missing (%) | 31.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3092.532778 |
|---|---|
| Minimum | 0 |
| Maximum | 1662560 |
| Zeros | 59 |
| Zeros (%) | < 0.1% |
| Memory size | 19.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 233 |
| median | 610 |
| Q3 | 1885 |
| 95-th percentile | 12680 |
| Maximum | 1662560 |
| Range | 1662560 |
| Interquartile range (IQR) | 1652 |
Descriptive statistics
| Standard deviation | 13643.41327 |
|---|---|
| Coefficient of variation (CV) | 4.411727943 |
| Kurtosis | 3758.552168 |
| Mean | 3092.532778 |
| Median Absolute Deviation (MAD) | 486 |
| Skewness | 44.79390898 |
| Sum | 5389768179 |
| Variance | 186142725.7 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 500 | 33744 | 1.3% | |
| 1000 | 15348 | 0.6% | |
| 600 | 5037 | 0.2% | |
| 800 | 4922 | 0.2% | |
| 12 | 4329 | 0.2% | |
| 400 | 4212 | 0.2% | |
| 700 | 4106 | 0.2% | |
| 200 | 3942 | 0.2% | |
| 13 | 3936 | 0.2% | |
| 300 | 3915 | 0.2% | |
| Other values (41322) | 1659342 | 65.4% | |
| (Missing) | 792958 | 31.3% |
| Value | Count | Frequency (%) | |
| 0 | 59 | < 0.1% | |
| 1 | 3654 | 0.1% | |
| 2 | 3010 | 0.1% | |
| 3 | 2663 | 0.1% | |
| 4 | 2767 | 0.1% |
| Value | Count | Frequency (%) | |
| 1662560 | 1 | < 0.1% | |
| 1420388 | 1 | < 0.1% | |
| 1411524 | 7 | < 0.1% | |
| 1335003 | 19 | < 0.1% | |
| 1322177 | 33 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Code service CH | Reference document | 1 Articles CGI | 2 Articles CGI | 3 Articles CGI | 4 Articles CGI | 5 Articles CGI | No disposition | Date mutation | Nature mutation | Valeur fonciere | No voie | B/T/Q | Type de voie | Code voie | Voie | Code postal | Commune | Code departement | Code commune | Prefixe de section | Section | No plan | No Volume | 1er lot | Surface Carrez du 1er lot | 2eme lot | Surface Carrez du 2eme lot | 3eme lot | Surface Carrez du 3eme lot | 4eme lot | Surface Carrez du 4eme lot | 5eme lot | Surface Carrez du 5eme lot | Nombre de lots | Code type local | Type local | Identifiant local | Surface reelle bati | Nombre pieces principales | Nature culture | Nature culture speciale | Surface terrain | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 04/01/2019 | Vente | 37220.0 | 26.0 | NaN | RUE | 2730 | DE MONTHOLON | 1000.0 | BOURG-EN-BRESSE | 1 | 53 | NaN | AI | 298 | NaN | 8 | 19.27 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 2.0 | Appartement | NaN | 20.0 | 1.0 | NaN | NaN | NaN |
| 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 04/01/2019 | Vente | 185100.0 | 22.0 | NaN | RUE | 1650 | GEN DELESTRAINT | 1000.0 | BOURG-EN-BRESSE | 1 | 53 | NaN | AM | 95 | NaN | 137 | NaN | 154 | 61.51 | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 2.0 | Appartement | NaN | 62.0 | 3.0 | NaN | NaN | NaN |
| 2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 04/01/2019 | Vente | 185100.0 | 22.0 | B | RUE | 1650 | GEN DELESTRAINT | 1000.0 | BOURG-EN-BRESSE | 1 | 53 | NaN | AM | 95 | NaN | 7 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 3.0 | Dépendance | NaN | 0.0 | 0.0 | NaN | NaN | NaN |
| 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 08/01/2019 | Vente | 209000.0 | 3.0 | NaN | RUE | 0043 | DES CHAMPAGNES | 1160.0 | PRIAY | 1 | 314 | NaN | E | 1676 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 1.0 | Maison | NaN | 90.0 | 4.0 | S | NaN | 940.0 |
| 4 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 07/01/2019 | Vente | 134900.0 | 5.0 | NaN | LOT | A003 | LE BIOLAY | 1370.0 | SAINT-ETIENNE-DU-BOIS | 1 | 350 | NaN | AA | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 1.0 | Maison | NaN | 101.0 | 5.0 | S | NaN | 490.0 |
| 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 03/01/2019 | Vente | 192000.0 | 165.0 | NaN | ALL | 0445 | DES LIBELLULES | 1340.0 | ATTIGNAT | 1 | 24 | NaN | AI | 94 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 1.0 | Maison | NaN | 88.0 | 4.0 | S | NaN | 708.0 |
| 6 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 08/01/2019 | Vente | 45000.0 | 9.0 | NaN | RTE | 0001 | DU VIADUC | 1250.0 | CIZE | 1 | 106 | NaN | A | 86 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 1.0 | Maison | NaN | 39.0 | 2.0 | S | NaN | 631.0 |
| 7 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 08/01/2019 | Vente | 45000.0 | NaN | NaN | NaN | B017 | SUR LA LATIE | 1250.0 | CIZE | 1 | 106 | NaN | A | 975 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | L | NaN | 120.0 |
| 8 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 04/01/2019 | Vente | 65000.0 | 50.0 | NaN | RUE | 1240 | DOC NODET | 1000.0 | BOURG-EN-BRESSE | 1 | 53 | NaN | AL | 3 | NaN | 317 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 3.0 | Dépendance | NaN | 0.0 | 0.0 | NaN | NaN | NaN |
| 9 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 04/01/2019 | Vente | 65000.0 | 50.0 | NaN | RUE | 1240 | DOC NODET | 1000.0 | BOURG-EN-BRESSE | 1 | 53 | NaN | AL | 3 | NaN | 17 | NaN | 33 | 67.78 | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 2.0 | Appartement | NaN | 69.0 | 3.0 | NaN | NaN | NaN |
Last rows
| Code service CH | Reference document | 1 Articles CGI | 2 Articles CGI | 3 Articles CGI | 4 Articles CGI | 5 Articles CGI | No disposition | Date mutation | Nature mutation | Valeur fonciere | No voie | B/T/Q | Type de voie | Code voie | Voie | Code postal | Commune | Code departement | Code commune | Prefixe de section | Section | No plan | No Volume | 1er lot | Surface Carrez du 1er lot | 2eme lot | Surface Carrez du 2eme lot | 3eme lot | Surface Carrez du 3eme lot | 4eme lot | Surface Carrez du 4eme lot | 5eme lot | Surface Carrez du 5eme lot | Nombre de lots | Code type local | Type local | Identifiant local | Surface reelle bati | Nombre pieces principales | Nature culture | Nature culture speciale | Surface terrain | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2535781 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 3.0 | Dépendance | NaN | 0.0 | 0.0 | S | NaN | 470.0 |
| 2535782 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 2.0 | Appartement | NaN | 70.0 | 3.0 | S | NaN | 470.0 |
| 2535783 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 2.0 | Appartement | NaN | 47.0 | 1.0 | S | NaN | 470.0 |
| 2535784 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 2.0 | Appartement | NaN | 55.0 | 2.0 | S | NaN | 470.0 |
| 2535785 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 2.0 | Appartement | NaN | 66.0 | 4.0 | S | NaN | 470.0 |
| 2535786 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 2.0 | Appartement | NaN | 120.0 | 5.0 | S | NaN | 470.0 |
| 2535787 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 05/12/2019 | Vente | 17521000.0 | 32.0 | NaN | QUAI | 0940 | DE BETHUNE | 75004.0 | PARIS 04 | 75 | 104 | NaN | AU | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 3.0 | Dépendance | NaN | 0.0 | 0.0 | S | NaN | 470.0 |
| 2535788 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 10/10/2019 | Adjudication | 610000.0 | 12.0 | NaN | RUE | 0797 | BEAUTREILLIS | 75004.0 | PARIS 04 | 75 | 104 | NaN | AQ | 40 | NaN | 2 | NaN | 35 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 2.0 | Appartement | NaN | 44.0 | 2.0 | NaN | NaN | NaN |
| 2535789 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 30/12/2019 | Vente | 1400000.0 | 24.0 | NaN | RUE | 8752 | SAINT SAUVEUR | 75002.0 | PARIS 02 | 75 | 102 | NaN | AM | 18 | NaN | 3 | 101.4 | 4 | 43.7 | 8 | NaN | NaN | NaN | NaN | NaN | 3 | 4.0 | Local industriel. commercial ou assimilé | NaN | 100.0 | 0.0 | NaN | NaN | NaN |
| 2535790 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 30/12/2019 | Vente | 1400000.0 | 24.0 | NaN | RUE | 8752 | SAINT SAUVEUR | 75002.0 | PARIS 02 | 75 | 102 | NaN | AM | 18 | NaN | 10 | 43.7 | 14 | 55.4 | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 2.0 | Appartement | NaN | 97.0 | 3.0 | NaN | NaN | NaN |